USE [FilestreamWpfHttp];
GO

IF OBJECT_ID('dbo.media', 'U') IS NOT NULL
  DROP TABLE [dbo].[media];
GO

CREATE TABLE [dbo].[media] (
	[mediaId] [uniqueidentifier] NOT NULL ROWGUIDCOL PRIMARY KEY,
	[fileName] [nvarchar](256) NOT NULL,
	[contentType] [nvarchar](256) NOT NULL,
	[file] [varbinary](max) FILESTREAM DEFAULT(0x));
GO
